Of note, the switch between CleanChoice and Pepco. It makes Feb 2021 unusually low, and June 2023 unusually high.
Also, the last month will probably be off. Not completely billed yet.
'\n(with code cells:)\njupyter nbconvert --to html --execute utilities_313_EDA.ipynb\n\n(without code cells:)\njupyter nbconvert --to html --execute --TemplateExporter.exclude_input=True utilities_313_EDA.ipynb\n'
| Amount | Year | Month | |
|---|---|---|---|
| count | 236.000000 | 236.000000 | 236.000000 |
| mean | 86.538771 | 2022.449153 | 6.453390 |
| std | 68.181854 | 1.278945 | 3.581565 |
| min | 0.000000 | 2020.000000 | 1.000000 |
| 25% | 18.000000 | 2021.000000 | 3.000000 |
| 50% | 79.990000 | 2022.000000 | 6.000000 |
| 75% | 137.022500 | 2023.250000 | 10.000000 |
| max | 370.090000 | 2025.000000 | 12.000000 |
Note the Pepco / CleanChoice data. After this, they'll be consolidated into "Electric"
| Amount | Amount_per_person | |
|---|---|---|
| count | 53.000000 | 53.000000 |
| mean | 385.342453 | 128.447484 |
| std | 88.659247 | 29.553082 |
| min | 192.990000 | 64.330000 |
| 25% | 335.200000 | 111.733333 |
| 50% | 387.540000 | 129.180000 |
| 75% | 420.660000 | 140.220000 |
| max | 628.080000 | 209.360000 |
<Figure size 1000x600 with 0 Axes>